//package com.kx.yooli.kx.wechat.mapper.lk;
//
//import com.mybatisflex.core.BaseMapper;
//import com.mybatisflex.core.query.QueryWrapper;
//
//import java.util.Map;
//
//public interface ILoanLkContractInfo extends BaseMapper<Map<String,Object>> {
//    default Object selectByLoanNo(String loanNo){
//        QueryWrapper qw = new QueryWrapper();
//        qw.select("cl.ID,cl.USER_ID,cl.LOAN_NO,cl.LOAN_NO_MINOR,cl.CUST_NAME," +
//                        "cl.CONTRACT_STATUS,cle.LOAN_INSTALMENTS,cle.LOAN_AMOUNT,cle.PUT_AMOUNT")
//                .from("CARD_LOAN_CONTRACT").as("cl")
//                .leftJoin("CARD_LOAN_CONTRACT_EXT").as("cle").on("cle.loan_no = cl.loan_no").and("loan_no="+loanNo);
//        return selectObjectByQuery(qw);
//    }
//}
